(Sun Microsystems, Inc.)(1997).iso/products/images/banner2.jpg)
Main Search Page Sub-category
Data Integration Inc.
With InterViso IVQuery an enterprise can: -- Use current dataeffectively and eliminate further proliferation of data -- Provide astandardized view across databases to ad hoc users and programmers --Push data transformation logic from application programs into a server- Isolate application programs from data migration as databases are
redesigned and converted InterViso IVQuery provides a layer betweenuser interface tools and/or application programs and gateway products togive the user or developer a standardized view across multiple existing,autonomous databases on a network. All data location and resolution ofstructure, data, and language differences is done automatically based onthe information supplied by the InterViso Data Dictionary (DD/D) Builder(see the related listing). The IVQuery optimizer handles joins andunions across databases and handles redundant data (replicated tables)and logical tables split across databases (fragmented tables). It willcoordinate updates to replicated or fragmented tables. The translatorshandle translation of data used in a query form federated to localschema, format, and data units; translation of data returned from localunits to federated units; and display of an integrated report. Theend-user interacts with IVQuery through an application program developedby the end-user organization, through an interactive interface providedwith IVQuery, or through batch jobs. The query is expressed in SQL andmay include SELECT, update (UPDATE, INSERT, or DELETE), and SELECT INTO(to store the output into a DBMS). IVQuery's API (application programinterface) conforms to the ODBC standard and may run on a PC or UNIXworkstation. Application programs may be written in a 4GL or otherapplication development tool. When used with InterViso, the applicationprogram does not need to include the logic to transform data and toresolve differences across databases. Standard transformations aredefined once, stored in the DD/D, and shared by all programs. Data maybe migrated to a new DBMS or designed without affecting the view seen bythe application programs. The IVQuery server resides on a SunOS(TM),but the databases may reside on any computer that may be reached via anetwork from the SunOS. Access to the databases is provided through DIIgateways to UNIX databases or through Cross Access, EDA/SQL, Sybase, orOracle SQL*Net gateways to mainframe databases. DII supplies a toolkitfor writing interfaces to non-standard data sources such as applicationprogram data. Data may be warehoused into any DBMS where the gatewaysupports the creation of new records. A pillar of the design ofInterViso is local autonomy of the existing databases. This means thatno changes to the database or DBMS are required to run IVQuery. Oldapplication programs continue to run. The owners of each databasecontrol access to their data through InterViso. There is no requirementto share all data with users of the network. InterViso adds anadditional layer of protection through access lists and views. IVQuerykeeps a history of logins, queries submitted, and error messages.
Language: C
Source Avail: No
Product Special Handling: DBMS gateways
Operating Systems: Solaris Sparc 1.0,2.3,2.4
Data Integration Inc.
11965 Venice Blvd Suite 305
Los Angeles, CA 90066
USA
Phone: (310) 313-9150
Fax: (310) 313-9151